Oracle and Cognos Developer

About

Description

We are seeking an experienced Senior Oracle and Cognos Developer to join our Financial Services Analytics & Reporting team. The successful candidate will design, develop, and maintain enterprise-grade data solutions and business intelligence (BI) reports for broker commission data across multiple insurance and financial product lines (e.g., Life, Health, Insurance).The role requires deep technical expertise in Oracle database development, Cognos BI reporting, and commission data modeling, combined with strong knowledge of financial services processes and regulatory requirements. You will play a pivotal role in ensuring accurate, timely, and insightful commission reporting for stakeholders, including Sales, Finance, Compliance, and Executive Management.

Responsibilities

• Design, develop, and maintain Oracle PL/SQL packages, stored procedures, triggers, and functions for commission data processing
• Optimize complex SQL queries for performance, scalability, and reliability in large datasets
• Design and maintain data models to support commission tracking, broker hierarchy structures, and payout rules
• Implement ETL processes to extract, transform, and load commission data from multiple source systems into reporting databases

Qualifications

• BSc in Computer Sciences/ Information Systems or equivalent IT tertiary qualification? Oracle Certified Professional - Advanced PLSQL developer

Application instructions:

• Click the green button to apply